// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_PROD_PICKING_MATERIAL_ITEM
// * CreateDate    : 2012/4/10 17:12:18
// * Creater       : CodeSmith
// * LastChangeDate: 2012/4/10 17:12:18
// * LastChanger   : 2012/4/10 17:12:18
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
    [Serializable]
    public partial class ProdPickingMaterialItemTable : TableInfo
    {
        public const string C_TableName = "PROD_PICKING_MATERIAL_ITEM";

        public const string C_PICKING_MATERIAL_ITEM_ID = "PICKING_MATERIAL_ITEM_ID";
        public const string C_PICKING_MATERIAL_ID = "PICKING_MATERIAL_ID";
        public const string C_PLAN_ORDER_ITEM_ID = "PLAN_ORDER_ITEM_ID";
        public const string C_MATERIAL_ID = "MATERIAL_ID";
        public const string C_PRODUCT_TECHNIC_ID = "PRODUCT_TECHNIC_ID";
        public const string C_QTY = "QTY";
        public const string C_UNIT_QTY = "UNIT_QTY";
        public const string C_NET_SIZE = "NET_SIZE";
        public const string C_GROSS_SIZE = "GROSS_SIZE";
        public const string C_REQUIRED_TOTAL_WEIGHT = "REQUIRED_TOTAL_WEIGHT";
        public const string C_ACTUAL_TOTAL_WEIGHT = "ACTUAL_TOTAL_WEIGHT";
        public const string C_UNIT_WEIGHT = "UNIT_WEIGHT";
        public const string C_TOTAL_WEIGHT = "TOTAL_WEIGHT";
        public const string C_PICKING_TYPE = "PICKING_TYPE";
        public const string C_PICKING_MODEL = "PICKING_MODEL";
        public const string C_UNIT = "UNIT";
        public const string C_STATUS = "STATUS";
        public const string C_PLAN_DELIVERY_DATE = "PLAN_DELIVERY_DATE";

        public ProdPickingMaterialItemTable()
        {
            _tableName = "PROD_PICKING_MATERIAL_ITEM";
        }

        protected static ProdPickingMaterialItemTable _current;
        public static ProdPickingMaterialItemTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }

        private static void Initial()
        {
            _current = new ProdPickingMaterialItemTable();

            _current.Add(C_PICKING_MATERIAL_ITEM_ID, new ColumnInfo(C_PICKING_MATERIAL_ITEM_ID, "PickingMaterialItemId", true, typeof(string)));
            _current.Add(C_PICKING_MATERIAL_ID, new ColumnInfo(C_PICKING_MATERIAL_ID, "PickingMaterialId", false, typeof(string)));
            _current.Add(C_PLAN_ORDER_ITEM_ID, new ColumnInfo(C_PLAN_ORDER_ITEM_ID, "PlanOrderItemId", false, typeof(string)));
            _current.Add(C_MATERIAL_ID, new ColumnInfo(C_MATERIAL_ID, "MaterialId", false, typeof(string)));
            _current.Add(C_PRODUCT_TECHNIC_ID, new ColumnInfo(C_PRODUCT_TECHNIC_ID, "ProductTechnicId", false, typeof(string)));
            _current.Add(C_QTY, new ColumnInfo(C_QTY, "Qty", false, typeof(decimal)));
            _current.Add(C_UNIT_QTY, new ColumnInfo(C_UNIT_QTY, "UnitQty", false, typeof(decimal)));
            _current.Add(C_NET_SIZE, new ColumnInfo(C_NET_SIZE, "NetSize", false, typeof(string)));
            _current.Add(C_GROSS_SIZE, new ColumnInfo(C_GROSS_SIZE, "GrossSize", false, typeof(string)));
            _current.Add(C_REQUIRED_TOTAL_WEIGHT, new ColumnInfo(C_REQUIRED_TOTAL_WEIGHT, "RequiredTotalWeight", false, typeof(decimal)));
            _current.Add(C_ACTUAL_TOTAL_WEIGHT, new ColumnInfo(C_ACTUAL_TOTAL_WEIGHT, "ActualTotalWeight", false, typeof(decimal)));
            _current.Add(C_UNIT_WEIGHT, new ColumnInfo(C_UNIT_WEIGHT, "UnitWeight", false, typeof(decimal)));
            _current.Add(C_TOTAL_WEIGHT, new ColumnInfo(C_TOTAL_WEIGHT, "TotalWeight", false, typeof(decimal)));
            _current.Add(C_PICKING_TYPE, new ColumnInfo(C_PICKING_TYPE, "PickingType", false, typeof(string)));
            _current.Add(C_PICKING_MODEL, new ColumnInfo(C_PICKING_MODEL, "PickingModel", false, typeof(decimal)));
            _current.Add(C_UNIT, new ColumnInfo(C_UNIT, "Unit", false, typeof(string)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS, "Status", false, typeof(string)));
            _current.Add(C_PLAN_DELIVERY_DATE, new ColumnInfo(C_PLAN_DELIVERY_DATE, "PlanDeliveryDate", false, typeof(DateTime)));

        }

        public ColumnInfo PICKING_MATERIAL_ITEM_ID
        {
            get { return this[C_PICKING_MATERIAL_ITEM_ID]; }
        }

        public ColumnInfo PICKING_MATERIAL_ID
        {
            get { return this[C_PICKING_MATERIAL_ID]; }
        }

        public ColumnInfo PLAN_ORDER_ITEM_ID
        {
            get { return this[C_PLAN_ORDER_ITEM_ID]; }
        }

        public ColumnInfo MATERIAL_ID
        {
            get { return this[C_MATERIAL_ID]; }
        }

        public ColumnInfo PRODUCT_TECHNIC_ID
        {
            get { return this[C_PRODUCT_TECHNIC_ID]; }
        }

        public ColumnInfo QTY
        {
            get { return this[C_QTY]; }
        }

        public ColumnInfo UNIT_QTY
        {
            get { return this[C_UNIT_QTY]; }
        }

        public ColumnInfo NET_SIZE
        {
            get { return this[C_NET_SIZE]; }
        }

        public ColumnInfo GROSS_SIZE
        {
            get { return this[C_GROSS_SIZE]; }
        }

        public ColumnInfo REQUIRED_TOTAL_WEIGHT
        {
            get { return this[C_REQUIRED_TOTAL_WEIGHT]; }
        }

        public ColumnInfo ACTUAL_TOTAL_WEIGHT
        {
            get { return this[C_ACTUAL_TOTAL_WEIGHT]; }
        }

        public ColumnInfo UNIT_WEIGHT
        {
            get { return this[C_UNIT_WEIGHT]; }
        }

        public ColumnInfo TOTAL_WEIGHT
        {
            get { return this[C_TOTAL_WEIGHT]; }
        }

        public ColumnInfo PICKING_TYPE
        {
            get { return this[C_PICKING_TYPE]; }
        }

        public ColumnInfo PICKING_MODEL
        {
            get { return this[C_PICKING_MODEL]; }
        }

        public ColumnInfo UNIT
        {
            get { return this[C_UNIT]; }
        }

        public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }

        public ColumnInfo PLAN_DELIVERY_DATE
        {
            get { return this[C_PLAN_DELIVERY_DATE]; }
        }



    }
}

